package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StorebarExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StorebarExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("BarCode is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("BarCode is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("BarCode =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("BarCode <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("BarCode >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BarCode >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("BarCode <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("BarCode <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("BarCode like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("BarCode not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("BarCode in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("BarCode not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("BarCode between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("BarCode not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNull() {
            addCriterion("DeptCode is null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNotNull() {
            addCriterion("DeptCode is not null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeEqualTo(String value) {
            addCriterion("DeptCode =", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotEqualTo(String value) {
            addCriterion("DeptCode <>", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThan(String value) {
            addCriterion("DeptCode >", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThanOrEqualTo(String value) {
            addCriterion("DeptCode >=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThan(String value) {
            addCriterion("DeptCode <", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThanOrEqualTo(String value) {
            addCriterion("DeptCode <=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLike(String value) {
            addCriterion("DeptCode like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotLike(String value) {
            addCriterion("DeptCode not like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIn(List<String> values) {
            addCriterion("DeptCode in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotIn(List<String> values) {
            addCriterion("DeptCode not in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeBetween(String value1, String value2) {
            addCriterion("DeptCode between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotBetween(String value1, String value2) {
            addCriterion("DeptCode not between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("Unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("Unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("Unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("Unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("Unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("Unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("Unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("Unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("Unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("Unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("Unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("Unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("Unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("Unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andOrgtypeIsNull() {
            addCriterion("OrgType is null");
            return (Criteria) this;
        }

        public Criteria andOrgtypeIsNotNull() {
            addCriterion("OrgType is not null");
            return (Criteria) this;
        }

        public Criteria andOrgtypeEqualTo(String value) {
            addCriterion("OrgType =", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeNotEqualTo(String value) {
            addCriterion("OrgType <>", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeGreaterThan(String value) {
            addCriterion("OrgType >", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeGreaterThanOrEqualTo(String value) {
            addCriterion("OrgType >=", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeLessThan(String value) {
            addCriterion("OrgType <", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeLessThanOrEqualTo(String value) {
            addCriterion("OrgType <=", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeLike(String value) {
            addCriterion("OrgType like", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeNotLike(String value) {
            addCriterion("OrgType not like", value, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeIn(List<String> values) {
            addCriterion("OrgType in", values, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeNotIn(List<String> values) {
            addCriterion("OrgType not in", values, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeBetween(String value1, String value2) {
            addCriterion("OrgType between", value1, value2, "orgtype");
            return (Criteria) this;
        }

        public Criteria andOrgtypeNotBetween(String value1, String value2) {
            addCriterion("OrgType not between", value1, value2, "orgtype");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNull() {
            addCriterion("PackSize is null");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNotNull() {
            addCriterion("PackSize is not null");
            return (Criteria) this;
        }

        public Criteria andPacksizeEqualTo(BigDecimal value) {
            addCriterion("PackSize =", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotEqualTo(BigDecimal value) {
            addCriterion("PackSize <>", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThan(BigDecimal value) {
            addCriterion("PackSize >", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize >=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThan(BigDecimal value) {
            addCriterion("PackSize <", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize <=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeIn(List<BigDecimal> values) {
            addCriterion("PackSize in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotIn(List<BigDecimal> values) {
            addCriterion("PackSize not in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize not between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceIsNull() {
            addCriterion("AdvicePrice is null");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceIsNotNull() {
            addCriterion("AdvicePrice is not null");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceEqualTo(BigDecimal value) {
            addCriterion("AdvicePrice =", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceNotEqualTo(BigDecimal value) {
            addCriterion("AdvicePrice <>", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceGreaterThan(BigDecimal value) {
            addCriterion("AdvicePrice >", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AdvicePrice >=", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceLessThan(BigDecimal value) {
            addCriterion("AdvicePrice <", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AdvicePrice <=", value, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceIn(List<BigDecimal> values) {
            addCriterion("AdvicePrice in", values, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceNotIn(List<BigDecimal> values) {
            addCriterion("AdvicePrice not in", values, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdvicePrice between", value1, value2, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andAdvicepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdvicePrice not between", value1, value2, "adviceprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceIsNull() {
            addCriterion("NormPrice is null");
            return (Criteria) this;
        }

        public Criteria andNormpriceIsNotNull() {
            addCriterion("NormPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNormpriceEqualTo(BigDecimal value) {
            addCriterion("NormPrice =", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceNotEqualTo(BigDecimal value) {
            addCriterion("NormPrice <>", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceGreaterThan(BigDecimal value) {
            addCriterion("NormPrice >", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NormPrice >=", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceLessThan(BigDecimal value) {
            addCriterion("NormPrice <", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NormPrice <=", value, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceIn(List<BigDecimal> values) {
            addCriterion("NormPrice in", values, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceNotIn(List<BigDecimal> values) {
            addCriterion("NormPrice not in", values, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NormPrice between", value1, value2, "normprice");
            return (Criteria) this;
        }

        public Criteria andNormpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NormPrice not between", value1, value2, "normprice");
            return (Criteria) this;
        }

        public Criteria andAdvicevippIsNull() {
            addCriterion("AdviceVipP is null");
            return (Criteria) this;
        }

        public Criteria andAdvicevippIsNotNull() {
            addCriterion("AdviceVipP is not null");
            return (Criteria) this;
        }

        public Criteria andAdvicevippEqualTo(BigDecimal value) {
            addCriterion("AdviceVipP =", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippNotEqualTo(BigDecimal value) {
            addCriterion("AdviceVipP <>", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippGreaterThan(BigDecimal value) {
            addCriterion("AdviceVipP >", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AdviceVipP >=", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippLessThan(BigDecimal value) {
            addCriterion("AdviceVipP <", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AdviceVipP <=", value, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippIn(List<BigDecimal> values) {
            addCriterion("AdviceVipP in", values, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippNotIn(List<BigDecimal> values) {
            addCriterion("AdviceVipP not in", values, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdviceVipP between", value1, value2, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andAdvicevippNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdviceVipP not between", value1, value2, "advicevipp");
            return (Criteria) this;
        }

        public Criteria andVippriceIsNull() {
            addCriterion("VipPrice is null");
            return (Criteria) this;
        }

        public Criteria andVippriceIsNotNull() {
            addCriterion("VipPrice is not null");
            return (Criteria) this;
        }

        public Criteria andVippriceEqualTo(BigDecimal value) {
            addCriterion("VipPrice =", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceNotEqualTo(BigDecimal value) {
            addCriterion("VipPrice <>", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceGreaterThan(BigDecimal value) {
            addCriterion("VipPrice >", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VipPrice >=", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceLessThan(BigDecimal value) {
            addCriterion("VipPrice <", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VipPrice <=", value, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceIn(List<BigDecimal> values) {
            addCriterion("VipPrice in", values, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceNotIn(List<BigDecimal> values) {
            addCriterion("VipPrice not in", values, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VipPrice between", value1, value2, "vipprice");
            return (Criteria) this;
        }

        public Criteria andVippriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VipPrice not between", value1, value2, "vipprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceIsNull() {
            addCriterion("PromPrice is null");
            return (Criteria) this;
        }

        public Criteria andPrompriceIsNotNull() {
            addCriterion("PromPrice is not null");
            return (Criteria) this;
        }

        public Criteria andPrompriceEqualTo(BigDecimal value) {
            addCriterion("PromPrice =", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceNotEqualTo(BigDecimal value) {
            addCriterion("PromPrice <>", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceGreaterThan(BigDecimal value) {
            addCriterion("PromPrice >", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromPrice >=", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceLessThan(BigDecimal value) {
            addCriterion("PromPrice <", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromPrice <=", value, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceIn(List<BigDecimal> values) {
            addCriterion("PromPrice in", values, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceNotIn(List<BigDecimal> values) {
            addCriterion("PromPrice not in", values, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromPrice between", value1, value2, "promprice");
            return (Criteria) this;
        }

        public Criteria andPrompriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromPrice not between", value1, value2, "promprice");
            return (Criteria) this;
        }

        public Criteria andPromstartIsNull() {
            addCriterion("PromStart is null");
            return (Criteria) this;
        }

        public Criteria andPromstartIsNotNull() {
            addCriterion("PromStart is not null");
            return (Criteria) this;
        }

        public Criteria andPromstartEqualTo(Date value) {
            addCriterion("PromStart =", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartNotEqualTo(Date value) {
            addCriterion("PromStart <>", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartGreaterThan(Date value) {
            addCriterion("PromStart >", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartGreaterThanOrEqualTo(Date value) {
            addCriterion("PromStart >=", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartLessThan(Date value) {
            addCriterion("PromStart <", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartLessThanOrEqualTo(Date value) {
            addCriterion("PromStart <=", value, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartIn(List<Date> values) {
            addCriterion("PromStart in", values, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartNotIn(List<Date> values) {
            addCriterion("PromStart not in", values, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartBetween(Date value1, Date value2) {
            addCriterion("PromStart between", value1, value2, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromstartNotBetween(Date value1, Date value2) {
            addCriterion("PromStart not between", value1, value2, "promstart");
            return (Criteria) this;
        }

        public Criteria andPromendIsNull() {
            addCriterion("PromEnd is null");
            return (Criteria) this;
        }

        public Criteria andPromendIsNotNull() {
            addCriterion("PromEnd is not null");
            return (Criteria) this;
        }

        public Criteria andPromendEqualTo(Date value) {
            addCriterion("PromEnd =", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendNotEqualTo(Date value) {
            addCriterion("PromEnd <>", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendGreaterThan(Date value) {
            addCriterion("PromEnd >", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendGreaterThanOrEqualTo(Date value) {
            addCriterion("PromEnd >=", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendLessThan(Date value) {
            addCriterion("PromEnd <", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendLessThanOrEqualTo(Date value) {
            addCriterion("PromEnd <=", value, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendIn(List<Date> values) {
            addCriterion("PromEnd in", values, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendNotIn(List<Date> values) {
            addCriterion("PromEnd not in", values, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendBetween(Date value1, Date value2) {
            addCriterion("PromEnd between", value1, value2, "promend");
            return (Criteria) this;
        }

        public Criteria andPromendNotBetween(Date value1, Date value2) {
            addCriterion("PromEnd not between", value1, value2, "promend");
            return (Criteria) this;
        }

        public Criteria andDmnoIsNull() {
            addCriterion("DMNo is null");
            return (Criteria) this;
        }

        public Criteria andDmnoIsNotNull() {
            addCriterion("DMNo is not null");
            return (Criteria) this;
        }

        public Criteria andDmnoEqualTo(String value) {
            addCriterion("DMNo =", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoNotEqualTo(String value) {
            addCriterion("DMNo <>", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoGreaterThan(String value) {
            addCriterion("DMNo >", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoGreaterThanOrEqualTo(String value) {
            addCriterion("DMNo >=", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoLessThan(String value) {
            addCriterion("DMNo <", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoLessThanOrEqualTo(String value) {
            addCriterion("DMNo <=", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoLike(String value) {
            addCriterion("DMNo like", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoNotLike(String value) {
            addCriterion("DMNo not like", value, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoIn(List<String> values) {
            addCriterion("DMNo in", values, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoNotIn(List<String> values) {
            addCriterion("DMNo not in", values, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoBetween(String value1, String value2) {
            addCriterion("DMNo between", value1, value2, "dmno");
            return (Criteria) this;
        }

        public Criteria andDmnoNotBetween(String value1, String value2) {
            addCriterion("DMNo not between", value1, value2, "dmno");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNull() {
            addCriterion("NewUpdate is null");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNotNull() {
            addCriterion("NewUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andNewupdateEqualTo(Date value) {
            addCriterion("NewUpdate =", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotEqualTo(Date value) {
            addCriterion("NewUpdate <>", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThan(Date value) {
            addCriterion("NewUpdate >", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewUpdate >=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThan(Date value) {
            addCriterion("NewUpdate <", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThanOrEqualTo(Date value) {
            addCriterion("NewUpdate <=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateIn(List<Date> values) {
            addCriterion("NewUpdate in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotIn(List<Date> values) {
            addCriterion("NewUpdate not in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateBetween(Date value1, Date value2) {
            addCriterion("NewUpdate between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotBetween(Date value1, Date value2) {
            addCriterion("NewUpdate not between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andSopriceIsNull() {
            addCriterion("SOPrice is null");
            return (Criteria) this;
        }

        public Criteria andSopriceIsNotNull() {
            addCriterion("SOPrice is not null");
            return (Criteria) this;
        }

        public Criteria andSopriceEqualTo(BigDecimal value) {
            addCriterion("SOPrice =", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceNotEqualTo(BigDecimal value) {
            addCriterion("SOPrice <>", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceGreaterThan(BigDecimal value) {
            addCriterion("SOPrice >", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SOPrice >=", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceLessThan(BigDecimal value) {
            addCriterion("SOPrice <", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SOPrice <=", value, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceIn(List<BigDecimal> values) {
            addCriterion("SOPrice in", values, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceNotIn(List<BigDecimal> values) {
            addCriterion("SOPrice not in", values, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SOPrice between", value1, value2, "soprice");
            return (Criteria) this;
        }

        public Criteria andSopriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SOPrice not between", value1, value2, "soprice");
            return (Criteria) this;
        }

        public Criteria andSostartdateIsNull() {
            addCriterion("SOStartDate is null");
            return (Criteria) this;
        }

        public Criteria andSostartdateIsNotNull() {
            addCriterion("SOStartDate is not null");
            return (Criteria) this;
        }

        public Criteria andSostartdateEqualTo(Date value) {
            addCriterion("SOStartDate =", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateNotEqualTo(Date value) {
            addCriterion("SOStartDate <>", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateGreaterThan(Date value) {
            addCriterion("SOStartDate >", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateGreaterThanOrEqualTo(Date value) {
            addCriterion("SOStartDate >=", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateLessThan(Date value) {
            addCriterion("SOStartDate <", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateLessThanOrEqualTo(Date value) {
            addCriterion("SOStartDate <=", value, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateIn(List<Date> values) {
            addCriterion("SOStartDate in", values, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateNotIn(List<Date> values) {
            addCriterion("SOStartDate not in", values, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateBetween(Date value1, Date value2) {
            addCriterion("SOStartDate between", value1, value2, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSostartdateNotBetween(Date value1, Date value2) {
            addCriterion("SOStartDate not between", value1, value2, "sostartdate");
            return (Criteria) this;
        }

        public Criteria andSoenddateIsNull() {
            addCriterion("SOEndDate is null");
            return (Criteria) this;
        }

        public Criteria andSoenddateIsNotNull() {
            addCriterion("SOEndDate is not null");
            return (Criteria) this;
        }

        public Criteria andSoenddateEqualTo(Date value) {
            addCriterion("SOEndDate =", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateNotEqualTo(Date value) {
            addCriterion("SOEndDate <>", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateGreaterThan(Date value) {
            addCriterion("SOEndDate >", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateGreaterThanOrEqualTo(Date value) {
            addCriterion("SOEndDate >=", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateLessThan(Date value) {
            addCriterion("SOEndDate <", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateLessThanOrEqualTo(Date value) {
            addCriterion("SOEndDate <=", value, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateIn(List<Date> values) {
            addCriterion("SOEndDate in", values, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateNotIn(List<Date> values) {
            addCriterion("SOEndDate not in", values, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateBetween(Date value1, Date value2) {
            addCriterion("SOEndDate between", value1, value2, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSoenddateNotBetween(Date value1, Date value2) {
            addCriterion("SOEndDate not between", value1, value2, "soenddate");
            return (Criteria) this;
        }

        public Criteria andSostarttimeIsNull() {
            addCriterion("SOStartTime is null");
            return (Criteria) this;
        }

        public Criteria andSostarttimeIsNotNull() {
            addCriterion("SOStartTime is not null");
            return (Criteria) this;
        }

        public Criteria andSostarttimeEqualTo(String value) {
            addCriterion("SOStartTime =", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeNotEqualTo(String value) {
            addCriterion("SOStartTime <>", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeGreaterThan(String value) {
            addCriterion("SOStartTime >", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeGreaterThanOrEqualTo(String value) {
            addCriterion("SOStartTime >=", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeLessThan(String value) {
            addCriterion("SOStartTime <", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeLessThanOrEqualTo(String value) {
            addCriterion("SOStartTime <=", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeLike(String value) {
            addCriterion("SOStartTime like", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeNotLike(String value) {
            addCriterion("SOStartTime not like", value, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeIn(List<String> values) {
            addCriterion("SOStartTime in", values, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeNotIn(List<String> values) {
            addCriterion("SOStartTime not in", values, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeBetween(String value1, String value2) {
            addCriterion("SOStartTime between", value1, value2, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSostarttimeNotBetween(String value1, String value2) {
            addCriterion("SOStartTime not between", value1, value2, "sostarttime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeIsNull() {
            addCriterion("SOEndTime is null");
            return (Criteria) this;
        }

        public Criteria andSoendtimeIsNotNull() {
            addCriterion("SOEndTime is not null");
            return (Criteria) this;
        }

        public Criteria andSoendtimeEqualTo(String value) {
            addCriterion("SOEndTime =", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeNotEqualTo(String value) {
            addCriterion("SOEndTime <>", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeGreaterThan(String value) {
            addCriterion("SOEndTime >", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeGreaterThanOrEqualTo(String value) {
            addCriterion("SOEndTime >=", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeLessThan(String value) {
            addCriterion("SOEndTime <", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeLessThanOrEqualTo(String value) {
            addCriterion("SOEndTime <=", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeLike(String value) {
            addCriterion("SOEndTime like", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeNotLike(String value) {
            addCriterion("SOEndTime not like", value, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeIn(List<String> values) {
            addCriterion("SOEndTime in", values, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeNotIn(List<String> values) {
            addCriterion("SOEndTime not in", values, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeBetween(String value1, String value2) {
            addCriterion("SOEndTime between", value1, value2, "soendtime");
            return (Criteria) this;
        }

        public Criteria andSoendtimeNotBetween(String value1, String value2) {
            addCriterion("SOEndTime not between", value1, value2, "soendtime");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceIsNull() {
            addCriterion("ULimitPrice is null");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceIsNotNull() {
            addCriterion("ULimitPrice is not null");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceEqualTo(BigDecimal value) {
            addCriterion("ULimitPrice =", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceNotEqualTo(BigDecimal value) {
            addCriterion("ULimitPrice <>", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceGreaterThan(BigDecimal value) {
            addCriterion("ULimitPrice >", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ULimitPrice >=", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceLessThan(BigDecimal value) {
            addCriterion("ULimitPrice <", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ULimitPrice <=", value, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceIn(List<BigDecimal> values) {
            addCriterion("ULimitPrice in", values, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceNotIn(List<BigDecimal> values) {
            addCriterion("ULimitPrice not in", values, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ULimitPrice between", value1, value2, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andUlimitpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ULimitPrice not between", value1, value2, "ulimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceIsNull() {
            addCriterion("DLimitPrice is null");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceIsNotNull() {
            addCriterion("DLimitPrice is not null");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceEqualTo(BigDecimal value) {
            addCriterion("DLimitPrice =", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceNotEqualTo(BigDecimal value) {
            addCriterion("DLimitPrice <>", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceGreaterThan(BigDecimal value) {
            addCriterion("DLimitPrice >", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DLimitPrice >=", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceLessThan(BigDecimal value) {
            addCriterion("DLimitPrice <", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DLimitPrice <=", value, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceIn(List<BigDecimal> values) {
            addCriterion("DLimitPrice in", values, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceNotIn(List<BigDecimal> values) {
            addCriterion("DLimitPrice not in", values, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DLimitPrice between", value1, value2, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andDlimitpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DLimitPrice not between", value1, value2, "dlimitprice");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateIsNull() {
            addCriterion("LabelPrintDate is null");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateIsNotNull() {
            addCriterion("LabelPrintDate is not null");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateEqualTo(Date value) {
            addCriterion("LabelPrintDate =", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateNotEqualTo(Date value) {
            addCriterion("LabelPrintDate <>", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateGreaterThan(Date value) {
            addCriterion("LabelPrintDate >", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateGreaterThanOrEqualTo(Date value) {
            addCriterion("LabelPrintDate >=", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateLessThan(Date value) {
            addCriterion("LabelPrintDate <", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateLessThanOrEqualTo(Date value) {
            addCriterion("LabelPrintDate <=", value, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateIn(List<Date> values) {
            addCriterion("LabelPrintDate in", values, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateNotIn(List<Date> values) {
            addCriterion("LabelPrintDate not in", values, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateBetween(Date value1, Date value2) {
            addCriterion("LabelPrintDate between", value1, value2, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andLabelprintdateNotBetween(Date value1, Date value2) {
            addCriterion("LabelPrintDate not between", value1, value2, "labelprintdate");
            return (Criteria) this;
        }

        public Criteria andSignIsNull() {
            addCriterion("Sign is null");
            return (Criteria) this;
        }

        public Criteria andSignIsNotNull() {
            addCriterion("Sign is not null");
            return (Criteria) this;
        }

        public Criteria andSignEqualTo(String value) {
            addCriterion("Sign =", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignNotEqualTo(String value) {
            addCriterion("Sign <>", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignGreaterThan(String value) {
            addCriterion("Sign >", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignGreaterThanOrEqualTo(String value) {
            addCriterion("Sign >=", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignLessThan(String value) {
            addCriterion("Sign <", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignLessThanOrEqualTo(String value) {
            addCriterion("Sign <=", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignLike(String value) {
            addCriterion("Sign like", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignNotLike(String value) {
            addCriterion("Sign not like", value, "sign");
            return (Criteria) this;
        }

        public Criteria andSignIn(List<String> values) {
            addCriterion("Sign in", values, "sign");
            return (Criteria) this;
        }

        public Criteria andSignNotIn(List<String> values) {
            addCriterion("Sign not in", values, "sign");
            return (Criteria) this;
        }

        public Criteria andSignBetween(String value1, String value2) {
            addCriterion("Sign between", value1, value2, "sign");
            return (Criteria) this;
        }

        public Criteria andSignNotBetween(String value1, String value2) {
            addCriterion("Sign not between", value1, value2, "sign");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}